
alter table userInvite add AccountCreated bit not null default (0)
alter table userInvite add LearnLanguage varchar(2) not null default 'en'

go

delete from countries where idcountry in( 'ag', 'gr', 'it')

update countries set idLanguage = 'en' 
where idcountry in ('uk', 'us')

update countries set idLanguage = 'es' 
where idcountry in ('es')

update countries set idLanguage = 'fr' 
where idcountry in ('fr', 'be')

go
